Airbnb, founded in 2008, has grown from a simple idea of renting out air mattresses in a San Francisco apartment to a global phenomenon in the hospitality industry. It has significantly altered the way people travel by offering unique accommodations from local hosts in over 100,000 cities worldwide. Its platform caters to a diverse range of preferences, from single rooms to entire homes, providing more personalized and often more cost-effective lodging options than traditional hotels. This peer-to-peer model has not only democratized travel accommodations but also enabled millions of hosts to generate additional income. As of 2022, Airbnb had hosted over 800 million guest arrivals, showcasing its vast growth and popularity among travelers seeking authentic experiences. This growth trajectory highlights Airbnb’s impact on the travel and tourism sector, prompting a reevaluation of traditional hospitality models and regulatory frameworks globally.
Airbnb’s rise has sparked controversies, especially around its impact on local housing markets, community dynamics, and regulatory compliance. The platform has been criticized for contributing to housing shortages by converting long-term rental properties into short-term tourist accommodations, leading to increased rent and property prices. In cities like Barcelona, this has exacerbated existing tensions between residents and tourists, contributing to over-tourism and altering neighborhood characters. Additionally, Airbnb has faced legal challenges regarding compliance with local housing laws and regulations, with accusations of facilitating illegal rentals. These issues have prompted cities worldwide to implement stricter regulations on short-term rentals, balancing the need for tourism revenue with protecting residents’ interests and preserving housing affordability.
Recently, Airbnb has seen a noticeable increase in rental prices, attributed to a combination of factors including heightened demand, limited supply, and the gradual recovery of the travel industry post-pandemic. This surge reflects a broader trend in the accommodation sector where prices are climbing as travelers return in large numbers, seeking unique and safe lodging options. The rise in prices has sparked discussions on affordability and access, urging both Airbnb and hosts to balance profitability with providing value to guests.
Airbnb’s controversies in Barcelona have been a focal point of discussions about the impact of short-term rentals on cities globally. Barcelona, a prime tourist destination, has faced significant challenges due to the proliferation of Airbnb listings, leading to tensions between the platform, the city’s residents, and local authorities.
One major controversy revolves around housing affordability and availability. Critics argue that Airbnb contributes to rising rents and the displacement of long-term residents in favor of short-term tourists. The city has seen protests from local groups and activists who claim that neighborhoods have lost their identity and cohesion due to the influx of tourists staying in Airbnb properties. These concerns have been echoed by housing advocacy groups like the Platform for People Affected by Mortgages (PAH), which has been vocal about the negative impacts of short-term rentals on the local housing market.
The Barcelona City Council, led by Mayor Ada Colau, has taken a firm stance against illegal tourist rentals. Since coming to office in 2015, Colau has introduced strict regulations aimed at curbing the growth of short-term rental platforms like Airbnb. In 2016, the city imposed a moratorium on new tourist licenses and fined Airbnb €600,000 for listing unlicensed properties, highlighting the city’s commitment to enforcing its regulations.
Further actions were taken in subsequent years, including the introduction of the PEUAT (Special Urban Plan for Tourist Accommodation) in 2017, which aimed to limit the expansion of tourist accommodations and ensure a balance between tourism and local residents’ needs. Despite these measures, conflicts persist, with Airbnb arguing that the city’s approach is overly restrictive and harms local hosts who rely on income from short-term rentals.
Despite the significance of Airbnb data, the private nature of the company, being publicly listed, rules out its open publication. Consequently, an alternative approach is necessary for data collection. In this report, we opt to depend on robust and reliable projects that have already proven their significance in regulating this reservation platform, as well as data sourced directly from the municipality.
We have established two distinct sources of data, the first involves the Inside Airbnb project, while the second is taken from the Open Data portal of the Barcelona City Council.
The Inside Airbnb project is a comprehensive, independent online platform that provides data and analysis on the operations of Airbnb in cities around the world. It was started by activist and data scientist Murray Cox in 2016 as a response to the lack of transparency regarding how Airbnb’s business model impacts local housing markets, neighborhoods, and communities. The project aggregates publicly available information on Airbnb listings and reviews to present a more detailed picture of the platform’s presence in various cities.
Inside Airbnb has become a crucial resource for researchers, policymakers, journalists, and community groups concerned about the rapid growth of short-term rentals and their effect on cities. By offering detailed data on the number of listings, types of properties, location, pricing, and host information, the project sheds light on how Airbnb contributes to issues like housing affordability, gentrification, and regulatory compliance.
One of the most significant repercussions of the Inside Airbnb project has been its influence on public policy and regulation. Cities like New York, San Francisco, and Barcelona have used data from Inside Airbnb to understand the scale and impact of short-term rentals, leading to the development and enforcement of more stringent short-term rental regulations. For instance, New York City has implemented rules requiring hosts to register with the city, a move aimed at cracking down on illegal listings—a policy informed by insights gained from Inside Airbnb’s data.
Inside Airbnb’s work has not been without criticism, particularly from Airbnb and hosts who argue that the platform’s data might be misinterpreted or used to unjustifiably restrict short-term rentals. Nonetheless, the project’s impact in highlighting the need for balance between tourism benefits and community well-being remains undeniable.
In our case we have used the data set of the city of Barcelona through two files, one being the facelifts and the other being the GEOJson of the locations. The quality of the data is indisputable and has been recognized by various actors. Likewise, the update is continuous and we work with data from less than two months ago, these being from mid-December.
We thank Inside Airbnb for its collaboration with consumers and the governments in making this data public, easily reachable and visible.
The portal https://opendata-ajuntament.barcelona.cat/ is an initiative by the Barcelona City Council aimed at promoting transparency, citizen participation, and innovation through open access to public data. This digital platform offers a wide array of datasets on various city aspects such as transportation, environment, demographics, and economy, enabling developers, researchers, and the general public to analyze, create, and share applications that enhance the understanding and management of the city.
In our case we have used the data set of “Population of Barcelona aggregated by sex according to the Municipal Register of Inhabitants on January 1 of each year”. Barcelona City Council offers an easy-to-use API from which we have only indexed the fields of our interest.
We thank Barcelona City Council for its collaboration with citizens and general public for publishing this data of general interest.
The Municipal Consumer Information Office (OMIC) in Barcelona plays a crucial role in protecting consumer rights within the city. This institution provides essential services such as advice, mediation, and conflict resolution between consumers and businesses. Established to ensure that consumer rights are respected and promoted, OMIC offers a valuable resource for citizens facing issues with products or services.
OMIC operates in various areas, including handling complaints and claims, promoting responsible consumption practices, and educating about consumer rights. It also offers workshops and informative talks, contributing to raising awareness and educating consumers about their rights and how to effectively exercise them.
Additionally, OMIC monitors commercial practices within the city to ensure compliance with current consumer legislation. This includes inspecting commercial establishments and implementing corrective actions in cases of infringement. Its work is essential in maintaining a fair balance between consumer interests and those of businesses, promoting a transparent and fair market.
We consider that OMIC is the perfect client for a report that reflects the impact that Airbnb is having on the city of Barcelona. Likewise, and after the major controversies over the price increase that Airbnb has had lately, it is interesting to observe the profile of accommodation and large license holders that Barcelona City Council has had under its sights for years.
This study is the first phase and after adequate negotiation a second could be launched with much more detailed data.
Each entry collected by Inside Airbnb, corresponding to one geographical location or city, is structured unanimously in the following manner:
| Country/City | File Name | Description |
|---|---|---|
| Barcelona | listings.csv.gz | Detailed Listings data |
| Barcelona | calendar.csv.gz | Detailed Calendar Data |
| Barcelona | reviews.csv.gz | Detailed Review Data |
| Barcelona | listings.csv | Summary information and metrics for listings in (good for visualisations). |
| Barcelona | reviews.csv | Summary Review data and Listing ID (to facilitate time based analytics and visualisations linked to a listing). |
| Barcelona | neighbourhoods.csv | Neighbourhood list for geo filter. Sourced from city or open source GIS files. |
| Barcelona | neighbourhoods.geojson | GeoJSON file of neighbourhoods of the city. |
Given this recurring structure and the richness of the data, the initial goal of the project was to compare data from different European cities. This objective is evident in the code implementation for loading data into data frames, designed to be replicable and applicable to any city’s data, provided the files are loaded into the working directory and stored in folders named after the respective cities. This approach was eventually discarded, as it became clear that focusing on Barcelona as a study case is already in itself an interesting focus.
The data collected from Barcelona corresponds to the 13 of December, 2023.
The main source of data is the listings.csv file, which
contains a collection of 18,321 listings with 18 variables:
dim(Barcelona)
## [1] 18321 18
str(Barcelona)
## 'data.frame': 18321 obs. of 18 variables:
## $ id : num 17475 18674 198958 23197 32711 ...
## $ name : chr "Rental unit in 08013 Barcelona · ★4.40 · 1 bedroom · 1 bed · 1 bath" "Rental unit in Barcelona · ★4.33 · 3 bedrooms · 6 beds · 2 baths" "Rental unit in Barcelona · ★4.69 · 4 bedrooms · 6 beds · 2 baths" "Rental unit in Sant Adria de Besos · ★4.77 · 3 bedrooms · 4 beds · 2 baths" ...
## $ host_id : int 65623 71615 971768 90417 135703 440825 73163 1013855 1014050 73163 ...
## $ host_name : chr "Luca" "Mireia Maria" "Laura" "Etain (Marnie)" ...
## $ neighbourhood_group : chr "Eixample" "Eixample" "Sant Martí" "Sant Martí" ...
## $ neighbourhood : chr "la Dreta de l'Eixample" "la Sagrada Família" "Diagonal Mar i el Front Marítim del Poblenou" "el Besòs i el Maresme" ...
## $ latitude : num 41.4 41.4 41.4 41.4 41.4 ...
## $ longitude : num 2.17 2.17 2.21 2.22 2.17 ...
## $ room_type : chr "Entire home/apt" "Entire home/apt" "Entire home/apt" "Entire home/apt" ...
## $ price : int 140 121 304 200 79 48 120 120 150 226 ...
## $ minimum_nights : int 5 1 2 3 1 4 5 4 3 5 ...
## $ number_of_reviews : int 26 40 105 75 99 168 8 244 142 217 ...
## $ last_review : chr "2023-12-04" "2023-11-07" "2023-10-16" "2023-11-25" ...
## $ reviews_per_month : num 0.16 0.31 0.74 0.48 0.66 1.34 0.05 1.67 0.96 1.35 ...
## $ calculated_host_listings_count: int 1 30 9 2 3 1 3 1 1 3 ...
## $ availability_365 : int 32 39 137 300 297 18 90 129 0 228 ...
## $ number_of_reviews_ltm : int 9 7 26 11 16 29 0 44 22 27 ...
## $ license : chr "" "HUTB-002062" "HUTB-000926" "HUTB005057" ...
The interpretation of variables is the following:
id: numerical identifier for each listingname: name of the listinghost_id: numerical identifier for the host of the
listinghost_name: name of the host.neighbourhood: location information specifying the
neighborhood the listing is inneighbourhood_group: larger district grouping of
neighborhoods (simplified from 71 to 10 districts)latitude: latitude coordinate of the listinglongitude: longitude coordinate of the listingroom_type: categorical string describing the type of
roomprice: daily price of the listing in the local currency
(euro)minimum_nights: minimum number of nights the listing
can be bookednumber_of_reviews: number of reviews at the time the
data was capturedlast_review: date of the latest review for the
listingreviews_per_month: average number of reviews per month
for each listingcalculated_host_listings_count: number of listings by
the listing host, calculated directly from the dataavailability_365: availability of the listing in days
starting from the data capture day within the next yearnumber_of_reviews_ltm: number of reviews in the past 12
monthslicense: compliance with City Council; includes the
license ID number if available, otherwise, pending or emptyAs explained previously, the data from has been enriched with
official demographic information obtained via API from the Open Data BCN
project from the City Council. The topic of choice was “Population of
Barcelona aggregated by sex according to the Municipal Register of
Inhabitants on January 1 of each year”, found in the file
2023_pad_mdbas_sexe.csv, from which the population grouped
by neighbourhood and district was extracted and merged into our main
data frame. The indexed fields are:
Nom_Districte: name of the greater districtNom_Barri: name of the neighbourhoodValor: population countThe merge has been done for neighbourhood = Nom_Barri,
resulting in a new demographics column in our
Barcelona_md data frame (md for merged).
From a first assessment of the data it was observed that within it, additional numerical and categorical variables could be extracted and used to provide insightful details once plotted.
The name field was found to include among other
information the star rating from 0 to 5 preceded by a star character, a
pattern easily reproducible with regular expressions. With pipes and
filters it has been extracted as a numerical value and introduced as an
additional column. Cases where names do not contain a star rating are
listed as NA.
String items found under license were observed to either
contain a license ID matching the City Council’s figure HUTB (Habitatge
d’Ús Turístic de Barcelona), the word ‘Exempt’, or be missing at all. A
new variable LicenseGrouping was established to contain
three new categories: Exempt,
License is displayed and
License is not displayed.
By considering the variable
calculated_host_listings_count and referencing the Spanish
Housing Law of 12/2023, which outlines the differentiation between
small and large tenants when there are 5 or more properties involved, a
new categorical variable, TenantSizeGrouping, was
established to capture this observation.
There are four categories of room types displayed:
Entire home/apt, Private room,
Shared room, and Hotel room.
The Entire home/apt category has the highest count,
approaching the 10,000 mark, suggesting that entire apartments or homes
are the most common type of property listed in Barcelona. The
Private room category follows, with roughly half as many
listings as entire homes, indicating a significant presence in the
market but less than the full property rentals.
Shared rooms and Hotel rooms have
significantly fewer listings compared to the other two categories.
Shared rooms barely register on the scale, suggesting they are a less
popular option among the listings. Hotel rooms have the smallest count,
indicating that traditional hotel stays are much less commonly listed on
platforms likely compared to short-term rental options.
The visual emphasizes the prevalence of whole property rentals in Barcelona’s accommodation offerings, with a substantial secondary market for private rooms. The minimal presence of shared and hotel room listings could reflect market demand or possibly restrictions and regulations within the city.
This chart contrasts two categories of landlords:
Small tenant and Large tenant, based on the
Number of listings they possess. The category
Small tenant outnumbers Large tenant owned,
indicating a slightly higher prevalence of landlords with fewer
properties.
Given the context of rental tension zones, equality of small and tenants may suggest a rental market with a concentrated number of players, potentially increasing the likelihood of monopolistic behavior affecting rental prices. However, the recent legislation changed the definition of a large property owner from 10 to 5 properties. This meant that several former small tenants now qualify as large tenants, potentially altering the market dynamics and affecting the application of policies within stressed areas.
The number of listings from small tenants is over 9,000, a substantial figure that indicates the scale of their presence in the market. Large tenants listings, with a count above 8,000, although less than small tenants, represent a significant portion of the market as well. The data indicates that both small and large tenants play important roles in the housing ecosystem of Barcelona.
Regarding the law’s stipulations, if the large tenants’ listings are concentrated in areas where housing costs exceed 30% of household income or where rental prices have outpaced CPI by more than 3 percentage points, these areas could be designated as rental tension zones. This would trigger regulatory measures that could include rent capping or other controls to protect tenants.
It’s also worth noting that the presence of more small tenants could reflect a diverse range of property offerings, from single rooms to entire apartments, which may cater to different segments of the population. This might have a stabilizing effect on rental prices, as a diverse supply can meet varied demand. However, if small tenants begin to consolidate or if their listings push housing costs above the 30% income threshold, it could lead to increased regulatory scrutiny.
In conclusion, this chart suggests a competitive rental market in Barcelona, with a predominance of small tenants. With legislative changes, the landscape could shift, potentially impacting rent levels, housing availability, and the designation of rental tension zones. Stakeholders, including policymakers and market participants, would need to monitor these dynamics closely to understand the full implications of the law on the rental market.
This chart provides a detailed breakdown of Airbnb listings in
Barcelona by room type and neighbourhood group, with four distinct
categories of accommodation: entire home/apt,
hotel room, private room, and
shared room. The y-axis represents the number of listings,
which is not consistent across the categories, indicating the use of a
free scale within the facets to better display the range of data.
Focusing first on the Entire home/apt category, we
observe a pronounced peak in Eixample, with over 4,000
listings, which significantly overshadows the counts in other areas,
where the second-highest listing Ciutat Vella has just above
1,000. This indicates a heavy concentration of full-property rentals in
that particular part of the city, which shows that Eixample is
a popular central area known for tourist attractions.
The Hotel room category exhibits a very different
scale, peaking at around 80 listings in the most prominent
neighbourhood, being again Eixample for this category. This
suggests that hotel rooms are a minor part of the Airbnb market in
Barcelona or that hotels prefer to use other channels for renting out
rooms. There are several neighborhoods that do not even present a single
hotel listing.
For Private rooms, the distribution seems more even,
yet Eixample stands out with nearly 2,000 listings, which is
about triple the number of listings in the second next populous
neighborhood in this category, Sants-Montjuïc. The shape of the
graph is surprisingly similar to the
Entire home/apt.
The Shared room type displays the least number of
listings across neighborhoods, with the highest being under 80. The low
count could indicate that shared rooms are not a preferred choice for
visitors to Barcelona, or such listings are rare.
The vast discrepancy between the number of
Entire home/apt listings and other types suggests that
visitors to Barcelona may prefer the privacy and space of an entire
apartment. The data could also imply a potential regulatory environment
that either supports whole-home rentals or one that has yet to address
this preference in the sharing economy.
The chart is an excellent tool for stakeholders to assess market saturation in various neighborhoods and room types. For investors and property managers, areas with lower counts could represent potential growth opportunities. Conversely, neighborhoods with high listings might face more competition, affecting pricing strategies. For policymakers such as OMIC and the Barcelona City hall, such data can be crucial in understanding how short-term rentals are distributed across the city and may guide decisions on tourism management, zoning, and housing policies to balance the needs of residents and visitors.
This bar chart illustrates the number of Airbnb listings across different neighbourhoods in Barcelona. The most prominent feature is the overwhelming dominance of the Eixample neighbourhood, with the number of listings towering over other areas. This suggests Eixample is a highly sought-after area for tourists or visitors using Airbnb. In contrast, neighbourhoods like Nou Barris and Sant Andreu have far fewer listings, which may indicate less tourist activity or a lower availability of rental properties on Airbnb.
The distribution indicates a potential disparity in the spread of tourism across the city, with certain areas possibly facing higher pressure from tourist accommodation. It is very interesting to note that only considering Eixample the number of listings is greater than the sum of the last six neighborhoods. This could have implications for local housing markets, infrastructure demand, and urban planning. The chart effectively highlights the disparities and could serve as a basis for more detailed analysis on the impact of short-term rentals on the urban landscape of Barcelona. As mentioned, there are several areas that do not reach a few hundred listings, which indicates a very low concentration of Airbnbs in relation to the people who reside there.